# -*- coding: utf-8 -*-
"""
Created on Thu Apr  3 21:18:42 2025

@author: micha
"""

import pandas as pd

import sys

sys.path.append(r"C:\Michael\Albany LAIO Lab and Research Projects\Python Utilities")


'''
Flags
'''
autoscale=True # autoscale flag. If true use autoscale on figures
save_images=True # If true save images to disk.

Image_dir = "C:/Michael/Albany LAIO Lab and Research Projects/Is a profile worth/images/"

Data_dir = "C:/Michael/Albany LAIO Lab and Research Projects/Is a profile worth/data/"


Leader_Means_DF= pd.read_excel("C:/Michael/Albany LAIO Lab and Research Projects/Is a profile worth/TALID Version 1 Scores_by_Leader.xlsx")

Leader_Means_DF=Leader_Means_DF[Leader_Means_DF['Word_Count']>9999]


Max_Means=Leader_Means_DF.max()
Min_Means=Leader_Means_DF.min()

df1 = Min_Means.to_frame().T
df2 = Max_Means.to_frame().T

Observed_Range_DF = pd.concat([df1,df2]).reset_index()

Observed_Range_DF.to_excel(excel_writer=Data_dir+"Observed Mean Ranges.xlsx", index=False)  

#Now drop columns?
